Jennifer Whitlock
Jennifer Whitlock
Reactions
-
Re: COUNTIFS Formula in Sheet Summary Returning "#NO MATCH"
I managed to track down the issue, I think. One of the lines in my reference sheet was changed and one of the cells in the column I was running the formula on was now a #NO MATCH. When I corrected th…2 · -
Re: Multiple Criteria for INDEX/MATCH or VLOOKUP?
So this formula is working now: =INDEX(COLLECT({Account Number}, {Clinic Name}, Clinic@row, {Vendor Zoetis}, "Zoetis"), 1) There's still a few hiccups but I'm going to double check, as I th…1 ·
